Bank Reconciliation Initialisation

If Tourplan NX accounting has been used for a time prior to the Bank Reconciliation being used, then a Bank Reconciliation starting date needs to be determined and any existing transactions dated prior to the reconciliation start date need to be tagged to prevent them from appearing in the reconciliation in the future.

In other words remove by tagging all those transactions that will not appear on a future bank statement page.

If the Bank Reconciliation is being used from the outset, then the initialisation process is not necessary.

Bank Reconciliation Initialisation

About Bank Reconciliation

  1. Any edits to the date etc. can be made in the next screen.
  2. Click either the Grey Insert button or the Page line.
  3.  

    NOTE: When at least one transaction line has been tagged, an Audit Button becomes active. Clicking the Audit Button will open the currently highlighted transaction to provide full details of it.

    The example above is showing old transactions, which is not uncommon when the Bank Reconciliation is started some months or years after the system has been installed and used - generally as a result of a staggered implementation.

About Bank Reconciliation Fields

Reconciliation Date (Date-Time)

This defaults to todays date, but can be overridden to be the bank statement date.

Reconciliation User (Char 30)

This field defaults to the current logged in user, it can be overridden to another user name if required.

Page Number (Char 10)

The page number automatically increments by 1 from the previous reconciliation page number. This should match the page number of the bank statement being reconciled. The page number can be edited, but only if the accounting period the reconciliation is in is an open period.

Closing Page Balance (Numeric 16,4)

Enter the closing balance from the bank statement being reconciled.

Opening Page Balance (Display Only)

The closing balance from the previously reconciled bank statements